﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WMSSyncData.Model.WMSModel;
using WMSSyncData.Utils;

namespace WMSSyncData.DAL.MESTOWMS
{
    public class InStockRows_SemiFinishDAL : BaseSqlDBDAL<WMS_T_InStockRows>
    {
        public List<WMS_T_InStockRows> GetInStockRows()
        {
            var sql = @"select newid() as Guid, BillNo,RowNo,PartNumber,RealQty,Unit from wms_M_Instock where BillType in ('半成品出库','半成品入库') and Data_Status=1";

            var ds = SqlDBHelper.GetDataSet(sql);

            var resutl = MakeTablePackage(ds.Tables[0]);

            return resutl;
        }
    }
}
